2014-03-06 - 11739 - Enhancement - Exclude C1200 and C1700 from all the queries in BW #BExQueriesforCrystalReportsAnalysisTool

ENHANCEMENT

11739 - Exclude C1200 & C1700 from all BEx queries

Requirement Summary

---

Need to exclude C1200 & C1700 customers from all the BEx queries in BPD(BW 7.3 Development) and move the changes to BPQ & BPP via transports.

Admin Info

---

Purpose	To Exclude C1200 & C1700 customers from all BEx queries
Requested By	Mark Harris
Spec Created By	Chandramouli K
Spec Created Date	03/06/2014
Spec QA by	Uday Kumar P
Objects	0CUSTOMER, 0SOLD_TO
Document Status	Complete

References

---

Prior Tickets

None

Documents

Attached with related release note.

Functional Requirement

---

1. Need to create open transport requests in BPD(BW 7.3 Development).
2. Need to exclude C1200 & C1700 customers from all the BEx queries in BPD(BW 7.3 Development).
3. Need to collect all the queries belonging to a infoprovider into a single transport request.

Solution Summary

---

1. Create an open transport request in BPD.
2. Exclude C1200 & C1700 customers for 0CUSTOMER (or) 0SOLD_TO infoobject in the BEx filter section.
3. Collect all the queries for an infoprovider into the open transport request.
4. Transport it to BPQ for testing and move it to BPP after successful testing.

Test Plan

SNo	Test Scenario	Expected Results
1	Check whether the changes are collected in to the transport request	All the changes should be collected into the transport Rrquest.
2	Check if all the Intercompany Customers(42) are excluded in BEx query.	All Intercompany customers(42) should be excluded in BEx query.
3	Check if all the changes meets the BEx QA Standards as per checklist.	BEx Query should pass all the QA test cases as in checklist.

Solution Details

---

1. Create an Open transport request in BPD(BW 7.3 Development).
2. Exclude C1200 & C1700 customers for 0CUSTOMER (or) 0SOLD_TO infoobject in the BEx filter section.
3. Collect all the queries for an infoprovider into the open transport request.
4. Transport it to BPQ(BW 7.3 Quality) for testing and move it to BPP(BW 7.3 Production) after successful testing.

Issues

---

None